from ExcelUtil.ExcelUtilLib import merge_excel_with_sheetname_tool, merge_excel_with_same_sheetname_tool


if __name__ == '__main__':
    # origin_folder_path = r'DataSet/origin'  # 更换为你的文件夹路径
    # result_folder_path = r'DataSet/result'  # 更换为你的文件夹路径
    # merged_file_name = "merged"
    # # csv_util = CsvUtil(origin_folder_path, result_folder_path)
    # merged_file = merge_excel_with_sheetname_tool(origin_folder_path, result_folder_path, merged_file_name, "Sheet1")
    # print(f"合并后的文件保存在：{merged_file}")


    origin_folder_path = r'DataSet/origin'  # 更换为你的文件夹路径
    result_folder_path = r'DataSet/result'  # 更换为你的文件夹路径
    merged_file_name = "merged"
    # csv_util = CsvUtil(origin_folder_path, result_folder_path)
    merged_file = merge_excel_with_same_sheetname_tool(origin_folder_path, result_folder_path, merged_file_name)
    print(f"合并后的文件保存在：{merged_file}")
